Query and Return One

Command Prototype

iRet = Database.QueryOne(objDatabase ,sql, optionArgs)

Command Description

Execute a query SQL statement and return the first row of the query results

Parameter Description

Required Parameter

objDatabase--Database object, a database object created using the Create Database Object command (Database.CreateDB)

SQL--Query SQL statement

Optional Parameter

rdict--Whether to return a Dictionary

args--Sql statement parameter

return

iRet--The variable used to save the output of the function call